Release 10.1A: OpenEdge Getting Started:
Core Business Services


Using the preconfigured OpenEdge audit policies

By importing the predefined OpenEdge database audit policies, you can audit the events listed in Table B–1. For more information, see the Audit Policy Maintenance Help.

Table B–1: Predefined OpenEdge database audit policy events
Event ID
Event name
Event type
Event description
Policy name
100
_sys.user.create
Security
User account created.
PSC-UserAccounts
101
_sys.user.update
Security
User account updated.
PSC-UserAccounts
102
_sys.user.delete
Security
User account deleted.
PSC-UserAccounts
210
_sql.dba.create
Security
SQL DBA created.
PSC-Security
211
_sql.dba.update
Security
SQL DBA updated.
PSC-Security
212
_sql.dba.delete
Security
SQL DBA deleted.
PSC-Security
300
_sys.audit.policy.create
Audit
Audit policy record created.
PSC-Audit
301
_sys.audit.policy.update
Audit
Audit policy record updated.
PSC-Audit
302
_sys.audit.policy.delete
Audit
Audit policy record deleted.
PSC-Audit
400
_sql.tbl.priv.create
Security
SQL table privilege created.
PSC-Security
401
_sql.tbl.priv.update
Security
SQL table privilege updated.
PSC-Security
402
_sql.tbl.priv.delete
Security
SQL table privilege deleted.
PSC-Security
410
_sql.col.priv.create
Security
SQL column privilege created.
PSC-Security
411
_sql.col.priv.update
Security
SQL column privilege updated.
PSC-Security
412
_sql.col.priv.delete
Security
SQL column privilege deleted.
PSC-Security
420
_sql.seq.priv.create
Security
SQL sequence privilege created.
PSC-Security
421
_sql.seq.priv.update
Security
SQL sequence privilege updated.
PSC-Security
422
_sql.seq.priv.delete
Security
SQL sequence privilege deleted.
PSC-Security
500
_sys.auth.sys.create
Security
Authentication system created.
PSC-Security
501
_sys.auth.sys.update
Security
Authentication system updated.
PSC-Security
502
_sys.auth.sys.delete
Security
Authentication system deleted.
PSC-Security
505
_sys.auth.domain.create
Security
Authentication domain created.
PSC-Security
506
_sys.auth.domain.update
Security
Authentication domain updated.
PSC-Security
507
_sys.auth.domain.delete
Security
Authentication domain deleted.
PSC-Security
510
_sys.role.create
Security
Role definition created.
PSC-Security
511
_sys.role.update
Security
Role definition updated.
PSC-Security
512
_sys.role.delete
Security
Role definition deleted.
PSC-Security
515
_sys.role.assign.create
Security
Role assignment created.
PSC-Security
516
_sys.role.assign.update
Security
Role assignment updated.
PSC-Security
517
_sys.role.assign.delete
Security
Role assignment deleted.
PSC-Security
5000
_sys.tbl.create
Schema
Table created.
App-Schema
5001
_sys.tbl.trig.create
Schema
Table trigger created.
App-Schema
5002
_sys.fld.create
Schema
Table field created.
App-Schema
5003
_sys.fld.trig.create
Schema
Table field trigger created.
App-Schema
5004
_sys.index.create
Schema
Table index created.
App-Schema
5005
_sys.index.fld.create
Schema
Table index field created.
App-Schema
5010
_sys.tbl.update
Schema
Table updated.
App-Schema
5111
_sys.tbl.trig.update
Schema
Table trigger updated.
App-Schema
5012
_sys.fld.update
Schema
Table field updated.
App-Schema
5013
_sys.fld.trig.update
Schema
Table field trigger updated.
App-Schema
5014
_sys.index.update
Schema
Table index updated.
App-Schema
5015
_sys.index.fld.update
Schema
Table index field updated.
App-Schema
5020
_sys.tbl.delete
Schema
Table deleted.
App-Schema
5021
_sys.tbl.trig.delete
Schema
Table trigger deleted.
App-Schema
5022
_sys.fld.delete
Schema
Table field deleted.
App-Schema
5023
_sys.fld.trig.delete
Schema
Table field trigger deleted.
App-Schema
5024
_sys.index.delete
Schema
Table index deleted.
App-Schema
5025
_sys.index.fld.delete
Schema
Table index field deleted.
App-Schema
5030
_sys.seq.create
Schema
Sequence created.
App-Schema
5031
_sys.seq.update
Schema
Sequence updated.
App-Schema
5032
_sys.seq.delete
Schema
Sequence deleted.
App-Schema
5040
_sys.db.prop.create
Schema
Database property created.
App-Schema
5041
_sys.db.prop.update
Schema
Database property updated.
App-Schema
5100
_sys.db.rec.create
Data
Database record created.
PSC-App-Tables
5101
_sys.db.rec.update
Data
Database record updated.
PSC-App-Tables
5102
_sys.db.rec.delete
Data
Database record deleted.
PSC-App-Tables
10000
_sys.db.audit.enable
Audit
Database auditing enabled.
PSC-Audit
10001
_sys.db.audit.disable
Audit
Database auditing disabled.
PSC-Audit
10010
_sys.audit.policy.commit
Audit
Audit policy run-time update.
PSC-Audit
10100
_sys.db.start
Admin
Database started.
PSC-DB-Admin
10101
_sys.db.stop
Admin
Database stopped.
PSC-DB-Admin
10200
_sys.backup
Utility
Database backup.
PSC-DB-Admin
10201
_sys.restore
Utility
Database restore.
PSC-DB-Admin
10202
_sys.bindump
Utility
Database binary dump.
PSC-DB-Admin
10203
_sys.binload
Utility
Database binary load.
PSC-DB-Admin
10204
_sys.copy
Utility
Database copy.
PSC-DB-Admin
10205
_sys.tbl.move
Utility
Database table move.
PSC-DB-Admin
10206
_sys.idx.move
Utility
Database index move.
PSC-DB-Admin
10207
_sys.idx.check
Utility
Database index check.
PSC-DB-Admin
10208
_sys.idx.rebuild
Utility
Database index rebuild.
PSC-DB-Admin
10209
_sys.area.truncate
Utility
Database area truncate.
PSC-DB-Admin
10210
_sys.idx.fix
Utility
Database index fix.
PSC-DB-Admin
10211
_sys.sql.dump
Utility
Database SQL dump.
PSC-DB-Admin
10212
_sys.sql.load
Utility
Database SQL load.
PSC-DB-Admin
10213
_sys.txt.dump
Utility
Database text dump.
PSC-DB-Admin
10214
_sys.txt.load
Utility
Database text load.
PSC-DB-Admin
10300
_sys.audit.archive
Audit
Audit archive.
PSC-Audit
10301
_sys.audit.data.dump
Audit
Audit data dump.
PSC-Audit
10302
_sys.audit.data.load
Audit
Audit data load.
PSC-Audit
10303
_sys.audit.pol.dump
Audit
Audit policy dump.
PSC-Audit
10304
_sys.audit.pol.load
Audit
Audit policy load.
PSC-Audit
10305
_sys.audit.recoveradmin
Audit
DBA deleted last audit admin.
PSC-Audit
10500
_pvm.setdbuser.success
User
Database user identity set.
PSC-User
10501
_pvm.setdbuser.fail
User
Database user identity failed.
PSC-User
10510
_pvm.user.login.pass
User
User login success.
PSC-User
10511
_pvm.user.logout
User
User logout.
PSC-User
10512
_pvm.user.login.fail
User
User login failed.
PSC-User
10520
_sql.user.login.pass
User
SQL user login success.
PSC-User
10521
_sql.user.logout
User
SQL user logout.
PSC-User
10522
_sql.user.login.fail
User
SQL user login failed.
PSC-User
10600
_pvm.db.connect
User
Database connect.
PSC-User
10601
_pvm.db.disconnect
User
Database disconnect.
PSC-User
10610
_sql.db.connect
User
SQL database connect.
PSC-User
10611
_sql.db.disconnect
User
SQL database disconnect.
PSC-User
31998
_sys.app.context
Application
Application context.
Application
31999
_sys.app.eventgroup
Application
Audit event group.
Application
32000 and higher
user-defined
User-defined event.


Copyright © 2005 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095